This model dimension represents the Compatible Units and is based on the IFS Cloud dimension DIM_CMPUNT_COMPATIBLE_UNIT. All models that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Description (where applicable) |
Class | Class |
Company | Company Code |
Compatible Unit | Name + Description |
Compatible Unit Sq | Sequence Number, Internal Database Key |
Compatible Unit Type | Compatible Unit Type |
Configuration Id | Configuration Id |
CU Id | Compatible Unit Id |
Description | Compatible Unit Description |
Estimate Revision | Indicates if this is the revision used for estimations True =1, False =0 |
Parent Id | Parent Unit Id |
Parent Rev | Parent Unit Revision No |
Parent Seq | Parent Unit Sequence No |
Plant | Plant Description |
Project Id | Project ID |
Revision No | Revision Number |
Site | Site Code |
Status | Compatible Unit Status |
Template Id | Template unit ID from which Compatible Unit derived |
Template Revision No | Revision Number of Template unit, from which Compatible Unit derived |
Model Name |
Maintenance |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
COMPATIBLE UNIT | DIM_CMPUNT_COMPATIBLE_UNIT_TM | DIM_CMPUNT_COMPATIBLE_UNIT_BI | DIM_CMPUNT_COMPATIBLE_UNIT | On Line |